Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
Problem Note 50809: When you access DB2 under z/OS and the DB2 table contains a variable defined as DISTINCT or LOB, an error might occur
 |  |  |  |
Querying a DB2 table that contains a LOB or DISTINCT data type and selecting more than 25 variables might result in an error similar to the following:
The job might also fail with an 0C4 abend similar to one of the following:
The only workaround is to break up the query so that no more than 25 variables are returned at a time.
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
DB2 WARNING:
RESULT OF SQL STATEMENT:
DSN00237W SQLDA INCLUDES 50 SQLVAR ENTRIES, BUT 84 ARE REQUIRED BECAUSE AT
LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A DISTINCT TYPE
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: 237 SQLSTATE: 01594 SQLERRP: DSNXEDC3 ERROR: System abend 0C4 occurred in module SASSQX function SQLMEM at
offset 000098.
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASSQP SQPRSLV 000402 0
NOTE: SASSQLP SQLRSLV 0028A0 0
NOTE: SASSQLP SQLPREP 0000B8 0
NOTE: SASSQX SQLLOOP 0008DA 0
NOTE: SASSQL SASSQL 000302 0
NOTE: SASHOST UNKNOWN 002DD0 0
ERROR: Delete current task.
OR
ERROR: System abend 0C4 occurred in module SASXDBI function DESCRIB at offset
0000F4.Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M1 |